﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="thongke.aspx.cs" Inherits="webtracuudiem.thongke" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <style type="text/css">
        .auto-style2 {
            font-size: x-large;
            color: #FF3300;
            text-align: center;
            background-color: #FF9933;
        }
        .auto-style8 {
        }
        .auto-style7 {
            width: 1253px;
        }
        .auto-style3 {
            width: 174px;
        }
        .auto-style5 {
            width: 162px;
        }
        .auto-style19 {
            font-size: 14pt;
            color: #6699FF;
        }
        .auto-style20 {
            width: 34px;
            height: 25px;
        }
        .auto-style22 {
            width: 16px;
            height: 20px;
        }
        .auto-style23 {
            text-decoration: none;
        }
        .auto-style24 {
            background-color: #99CC00;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <table>
        <tr>
            <td class="auto-style2" colspan="4"><strong id="labQUANLYDIEM">THỐNG KÊ</strong></td>
            <td>
                <asp:Button ID="ButThoat" runat="server" Text="Đăng xuất" Width="97px" OnClick="ButThoat_Click" />
            </td>
        </tr>
        <tr>
            <td >&nbsp;</td>
            <td >&nbsp;</td>
            <td id="LABthongke" >&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td colspan="2" >Chọn Ngành</td>
            <td >&nbsp;</td>
            <td>Chọn Môn</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td id="labChonnganh" colspan="2">
                <asp:DropDownList ID="DropChonNganh" runat="server" Height="25px" style="margin-left: 5px" Width="200px" AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="TenNganh" DataValueField="MaNganh">
                </asp:DropDownList>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Demo1ConnectionString %>" SelectCommand="SELECT * FROM [NganhHoc]"></asp:SqlDataSource>
            </td>
            <td id="labChonMon">&nbsp;</td>
            <td>
                <asp:DropDownList ID="DropChonnmon" runat="server" Height="25px" style="margin-left: 5px" Width="200px" AutoPostBack="True" DataSourceID="SqlDataSource2" DataTextField="TenMH" DataValueField="MaMH">
                </asp:DropDownList>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:Demo1ConnectionString %>" SelectCommand="SELECT * FROM [MonHocCuaNganh],[monhoc] WHERE [MonHocCuaNganh].mamh=monhoc.mamh and  ([MaNganh] = @MaNganh)">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="DropChonNganh" Name="MaNganh" PropertyName="SelectedValue" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
        <tr>
            <td class="auto-style8">&nbsp;</td>
            <td class="auto-style7">&nbsp;</td>
            <td class="auto-style3">&nbsp;</td>
            <td class="auto-style5">&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td colspan="5" class="auto-style19">Xuất danh sách sinh viên theo yêu cầu</td>
        </tr>
        <tr>
            <td colspan="2">&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;
                <img alt="" class="auto-style20" src="images/right-arrow-icon.png" />Danh sách SV nợ môn</td>
            <td>
                &nbsp;</td>
            <td>
                <asp:Button ID="ButXuatFileExcel" runat="server" Text="Xuất File Excel" Width="143px" OnClick="ButXuatFileExcel_Click" />
            </td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td colspan="2">&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;
                <img alt="" class="auto-style20" src="images/right-arrow-icon.png" />Danh sách điểm theo ngành học</td>
            <td>
                &nbsp;</td>
            <td>
                <asp:Button ID="ButXuatFileExcel0" runat="server" Text="Xuất File Excel" Width="143px" OnClick="ButXuatFileExcel0_Click" />
            </td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td colspan="2">&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;
                <img alt="" class="auto-style20" src="images/right-arrow-icon.png" />Danh sách SV thi tốt nghiệp</td>
            <td>
                &nbsp;</td>
            <td>
                <asp:Button ID="ButXuatFileExcel1" runat="server" Text="Xuất File Excel" Width="143px" />
            </td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td colspan="2">&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;
                <img alt="" class="auto-style20" src="images/right-arrow-icon.png" />Danh sách SV không đủ ĐKTTN</td>
            <td>
                &nbsp;</td>
            <td>
                <asp:Button ID="ButXuatFileExcel2" runat="server" Text="Xuất File Excel" Width="143px" />
            </td>
            <td>
                <span><a href="TrangPhongDaoTao.aspx" class="auto-style23"><img alt="" src="images/Arrow_back.png" class="auto-style22" /> <span class="auto-style24">BACK</span></a></span></td>
        </tr>
    </table>
</asp:Content>
